Microsoft SQL Server data types

The following table shows the Microsoft SQL Server data warehouse data types that are supported when using Qlik Compose and the default mapping from Qlik Compose data types.

For information on how to view the data type that is mapped from the source, see the section for the source database you are using.

Data type mappings
Qlik Compose data types	Microsoft SQL Server data types
Bigint	BIGINT
Decimal	NUMERIC (p,s)
Integer	INT
Date	DATETIME2
Datetime	DATETIME2
GUID	UNIQUEIDENTIFIER
IntAutoInc	INT IDENTITY
Byte	VARBINARY (Length)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here